﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="OldClient.aspx.cs" Inherits="OldClient" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
        .style2
        {
            width: 107px;
            height: 32px;
        }
        .style3
        {
            height: 32px;
        }
        .style5
        {
            height: 32px;
            width: 160px;
        }
        .style6
        {
            height: 32px;
            width: 127px;
        }
        .style7
        {
            height: 32px;
            width: 181px;
        }
        .style8
        {
            height: 32px;
            width: 152px;
        }
        .style9
        {
            width: 89px;
            height: 32px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table style="width: 100%;">
        <tr>
            <td class="style2" style="text-align: left">
                Code :</td>
            <td class="style5" style="text-align: left">
                <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
            </td>
            <td class="style6" style="text-align: left">
            </td>
            <td class="style7" style="text-align: left">
            </td>
            <td class="style9" style="text-align: left">
                &nbsp;</td>
            <td class="style8" style="text-align: left">
            </td>
            <td class="style3" style="text-align: left">
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style2" style="text-align: left">
                First Name :</td>
            <td class="style5" style="text-align: left">
                <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" 
                    Enabled="False" Height="22px" Width="145px" DataSourceID="SqlDataSource1" 
                    DataTextField="firstname" DataValueField="firstname">
                </asp:DropDownList>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                    SelectCommand="SELECT DISTINCT [firstname] FROM [client] ORDER BY [firstname]">
                </asp:SqlDataSource>
            </td>
            <td class="style6" style="text-align: left">
                Middle Name :</td>
            <td class="style7" style="text-align: left">
                <asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" 
                    Enabled="False" Height="22px" Width="145px" DataSourceID="SqlDataSource2" 
                    DataTextField="middlename" DataValueField="middlename">
                </asp:DropDownList>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                    SelectCommand="SELECT DISTINCT [middlename] FROM [client] WHERE ([firstname] = @firstname) ORDER BY [middlename]">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="DropDownList1" Name="firstname" 
                            PropertyName="SelectedValue" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
            <td class="style9" style="text-align: left">
                Last Name :</td>
            <td class="style8" style="text-align: left">
                <asp:DropDownList ID="DropDownList3" runat="server" AutoPostBack="True" 
                    Height="22px" Width="145px" DataSourceID="SqlDataSource3" 
                    DataTextField="lastname" DataValueField="lastname" Enabled="False">
                </asp:DropDownList>
                <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                    SelectCommand="SELECT DISTINCT [lastname] FROM [client] WHERE (([firstname] = @firstname) AND ([middlename] = @middlename)) ORDER BY [lastname]">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="DropDownList1" Name="firstname" 
                            PropertyName="SelectedValue" Type="String" />
                        <asp:ControlParameter ControlID="DropDownList2" Name="middlename" 
                            PropertyName="SelectedValue" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
            <td class="style3" style="text-align: left">
                <asp:CheckBox ID="CheckBox1" runat="server" AutoPostBack="True" 
                    oncheckedchanged="CheckBox1_CheckedChanged" Text="Show" />
            </td>
        </tr>
        <tr>
            <td class="style2" style="text-align: left">
            </td>
            <td class="style5" style="text-align: left">
            </td>
            <td class="style6" style="text-align: left">
            </td>
            <td class="style7" style="text-align: left">
                <asp:Button ID="Button1" runat="server" Height="40px" Text="Add" 
                    Width="110px" onclick="Button1_Click" />
            </td>
            <td class="style9" style="text-align: left">
                &nbsp;</td>
            <td class="style8" style="text-align: left">
            </td>
            <td class="style3" style="text-align: left">
                &nbsp;</td>
        </tr>
    </table>
</asp:Content>

